EMT Practice Test

1. Question Content...

---

Question1: You have a measure with different names coming from two queries. How you determine which query each measure comes from?

Question2: For which tasks do you use an If() function?
There are 2 correct answers to this question.
Response:

Question3: Which panel should you use to view a Document Summary of a BusinessObjects Web Intelligence 4.0 document (WID)? Please choose the correct answer.
Response:

Question4: When using the ranking feature on a table, which expression allows you to display the total of all values (both ranked and unranked) in the footer of the block?

Question5: Which three calculations can you use in a measure object in Web Intelligence? There are 3 correct answers to this question.
Response:

Question6: How do you determine if a formula or a variable is used in a block? (2 answers)

Question7: How do you duplicate a query?
Please choose the correct answer.
Response:

Question8: Which two statements are true of grouping sets when using smart measures? Please choose the correct answer.
Response:

Question9: Which four Report Elements can you select from the Templates tab of Web Intelligence? There are 4 correct answers to this question.
Response:

Question10: Which two are running aggregate functions in Web Intelligence?
There are 2 correct answers to this question.
Response:

Question11: You have created a BusinessObjects Web Intelligence 4.0 document (WID) within InfoView that has a single table block on a single report page. Where will a new object be displayed when you add it to the query? Please choose the correct answer.
Response:

Question12: Which DaysBetween() function syntax should you use to calculate the number of years since your birth, assuming the date object is Birth_date? Please choose the correct answer.
Response:

Question13: Which of the following option is not a component of Web Intelligence Application Structure? Please choose the correct answer.
Response:

Question14: Name the types of query filters that you can use in Web Intelligence?
There are 3 correct answers to this question
Response:

Question15: To which destinations can you send a Web Intelligence document (WID) through InfoView of BusinessObjects Web Intelligence XI 4.0? There are 3 correct answers to this question.
Response:

Question16: You want to know which other stores' revenues match to exceed your store's revenue. You build a query using the sales revenue. What is the next step?

Question17: Where can you use a free-standing cell?

Question18: Why would you need to change the data source for your query?
Please choose the correct answer.
Response:

Question19: What is the purpose of Demonstration: To Create a Simple Web Intelligence Document? Please choose the correct answer.
Response:

Question20: Which statement describes the performance impact that data tracking has on report refresh times, assuming that the data changes but the number of rows retrieved and the data volume stays the same? Please choose the correct answer.
Response:

Question21: How much impact does data tracking have on the data size of a Web Intelligence document (WID) Compared to the same document without data tracking? Please choose the correct answer.
Response:

Question22: Discuss all the advantages link to organizing a report in the section
There are 2 correct answers to this question
Response:

Question23: How can you combine Microsoft Excel spreadsheet data with universe query data?

Question24: Which three are prerequisites for combining data from multiple data providers? There are 3 correct answers to this question.
Response:

Question25: Which two properties can you set in the hyperlink dialog box when you create a hyperlink to a document? There are 2 correct answers to this question.
Response:

Question26: Which three objects represent qualifications from a local data provider? There are 3 correct answers to this question.
Response:

Question27: You try to select a number of data objects from the Data tab to drag into a report, but some of them are grayed out and in italics. Which statement explains this behavior? Please choose the correct answer.
Response:

Question28: What actions can you perform in the Web Intelligence query panel? (3 answers)

Question29: Which tab should you use to change the page orientation of a report?
Please choose the correct answer.
Response:

Question30: Where can you set the default universe when using Web Intelligence within InfoView? Please choose the correct answer.
Response:

Question31: Which is a benefit of using query drill?
Please choose the correct answer.
Response:

Question32: Which two operators can you use with output context in the Web Intelligence Rich Client? There are 2 correct answers to this question.
Response:

Question33: Which two functions can you use to concatenate the strings "England" and "New" to create the string "New England"? There are 2 correct answers to this question.
Response:

Question34: You set the drill option "Prompt when drill requires additional data". Now you drill outside the scope of analysis on your report.
How does Web Intelligence respond?
Please choose the correct answer.
Response:

Question35: Which method should you use to activate "Interactive Viewing"?
Please choose the correct answer.
Response:

Question36: Which statement is true of an output context operator?
Please choose the correct answer.
Response:

Question37: Which method should you use to view alerts in a report?
Please choose the correct answer.
Response:

Question38: How do you allow a user to type a value for a prompt? (2 answers)

Question39: When scheduling Web Intelligence document, what output formats are available? (2 answers)

Question40: Which two personal folders are available by default to Web Intelligence users? There are 2 correct answers to this question.
Response:

Question41: Which three elements are parts of a query filter?
There are 3 correct answers to this question.
Response:

Question42: Discuss the components of a Web Intelligence Document?
There are 3 correct answers to this question
Response:

Question43: A document displays a data in the format: MM/DD/YY. What option allow you to change the format to DD/MM/YY? (2 answers)

Question44: Identify from the correct option from the following - To Navigate from Section to Section? Please choose the correct answer.
Response:

Question45: Which two statements are true of an ambiguous query?
There are 2 correct answers to this question.
Response:

Question46: You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context. Which output statement should you use? Please choose the correct answer.
Response:

Question47: Which operator allows you to enter more than one operand value?

Question48: Which reporting tool should you use to create a Web Intelligence document (WID) directly from an Excel data source? Please choose the correct answer.
Response:

Question49: Which method should you use to force each section of a report to start on a new page? Please choose the correct answer.
Response:

Question50: Which tool do you use to edit merged objects in BusinessObjects Web Intelligence 4.0? Please choose the correct answer.
Response:

Question51: Which two panels can you use to purge data from a BusinessObjects Web Intelligence 4.0 document (WID)? There are 2 correct answers to this question.
Response:

Question52: What option do you select to change the Total Revenue to a currency (shown in the attached graphic)?

Question53: In the Annual Revenue column, what formula calculates the total annual revenue in each row (shown in the attached graphic)?

Question54: How does the ForEach operator affect the default calculation context?

Question55: Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"? Please choose the correct answer.
Response:

Question56: Which table type looks most similar to a Microsoft Excel pivot table?

Question57: What object type is represented by the icon shown below?

Question58: What are the two relational operators that can be used with wildcard Characters, in a query filter? There are 2 correct answers to this question Response:

Question59: What are the benefits of using SAP Business Objects Web Intelligence? (2 answers)

Question60: Which two statements about the If() function are correct?
There are 2 correct answers to this question.
Response:

Question61: Which character should you use to reset the result of the RunningSum( ) function for either a break or a section? Please choose the correct answer.
Response:

Question62: Which of the following sequence is correct -To Insert a Block in Each Section? Please choose the correct answer.
Response:

Question63: What is the maximum number of sub-alerts that an alerter can contain?
Please choose the correct answer.
Response:

Question64: You have two columns: order date and ship date. How do you calculate the processing time from the order date to the ship date?

Question65: Which three statements about the If() function are correct?
There are 3 correct answers to this question.
Response:

Question66: You insert the function CurrentDate() into a cell. To clarify the date you add a string so that the formula is now:
= "Sales Report from "+CurrentDate()
Which formatting capability is disabled for the cell?
Please choose the correct answer.
Response:

Question67: How do you duplicate an existing query? (2 answers)

Question68: Where are contexts created?
Please choose the correct answer.
Response:

Question69: What is the input context of a calculation?

Question70: Which scenarios should you use breaks for?
There are 2 correct answers to this question.
Response:

Question71: Which three statements are true of calculation contexts?
There are 3 correct answers to this question.
Response:

Question72: Which two Web Intelligence Rich Client authentication methods enable you to export Web Intelligence documents (WID) to the Central Management Server (CMS)? There are 2 correct answers to this question.
Response:

Question73: Which of the following are extended syntax keywords? (2 answers)

Question74: How can you share Web Intelligence documents in your organization?
There are 2 correct answers to this question
Response:

Question75: Why would you use the FormatDate() function?
There are 2 correct answers to this question.
Response:

Question76: What do you use to search for content in multiple documents?

Question77: What is the correct formula for the RunningSum column (shown in the attached graphic)?

Question78: Elucidate the advantages of saving formulas as variables?
Please choose the correct answer.
Response: